> Product and projects / Projects / Project enquiries, analysis and reporting

Projects - Analysis and reporting

Accounts Plus and Accounts Professional only

Understanding a project's costs helps you manage projects more efficiently, make them more cost effective and determine your most profitable types of project. Sage 50 Accounts Project Costing provides the features you need to maintain accurate details about your projects, and helps you to track and evaluate the costs incurred.

Using Project Costing, you can enter and monitor all of the costs associated with each project. This means you know exactly how much it costs your business to complete a project, and how much to charge your customer to ensure that your business makes a profit. You can also avoid costly overruns by tracking expenditure.

You can also use Project Costing to track non-profitable or in-house projects.


To analyse your projects

Project Costing contains several features that help you to track projects, analyse costs and revenue and respond to customer enquiries about the progress of a project.

View individual project costs - transactions

There are two ways to do this:

  • You can view the transactions for a specific project record.
  • Alternatively you can search for transactions by date range or transaction type. To do this, Projects > Activity.

As well as the analysis features available within Project Costing, there is a tab on the Customer Record that displays details of every project associated with that customer, and each project's summary information at a glance.

View project costs and compare to budget

This can be done for a single project managed using the one project record or for a multi-level project that uses several project records. A variance appears that can indicate either an overspend or surplus on budget.

You can drill-down project costs to view the costs specifically by cost type, cost code and finally down to individual transactions.

You can choose to include committed costs when comparing costs to budgets.

Generate reports

Project Costing provides many useful analysis reports.

For example, from within Projects > Reports, you can run a report to analyse costs by project or by cost code. Other reports enable you to view revenue information, look at a list of projects by status, or check profitability.

To view project costs and compare to budget

  1. Projects > Enquiry.
  2. Project Reference > choose the project you want to view.
  3. To see a breakdown of the project’s costs, double-click a value. This opens the Cost v Budget - By Cost Type window.

    To see a more detailed breakdown, double-click a value on the Cost v Budget - By Cost Code window.

    To see a more detailed breakdown, double-click a value on the Cost Code Breakdown - Transactions window.

  4. To include sub projects in various calculations, select the Include sub projects check box. To include committed costs in the calculations, select the Include committed costs in variances check box.

To run a project report

  1. Projects > select the projects you want to report on > Reports.
  2. Double-click the area for the type of report that you want to run, for example Project details.
  3. Select the report you want to run > from the Report Browser toolbar, select the action you want to take, for example Preview.

    Depending on which report you run, the Criteria window may appear.

  4. To accept the criteria details and run the report > OK.

Tip: If you want to add the report to your Favourites, select the report, then click the star to the left of the report title.


To review Ask Sage, Business Advice and Health and Safety advice, go here. All contact details for Sage are available from here.

Go to top